# -*- coding: utf-8 -*-
import pandas as pd

f1 = open('D:\q20180629\qimo_close_price1.csv', 'rb')
f2 = open('D:\q20180629\qa.csv', 'rb')

data1 = pd.read_csv(f1)
data2 = pd.read_csv(f2)
data3 = pd.merge(data1, data2, how='left')
data3.to_excel('D:\q20180629\qimo_close_price_out_1.xlsx', index=False)
